﻿-- ===============================================================================================
-- Basic Reference: Country: http://www.iso.org/iso/english_country_names_and_code_elements
-- ===============================================================================================

DELETE FROM [esf_sso].[TreeBasicReference] WHERE BasicReferenceID IN (SELECT ID FROM [esf_sso].[BasicReference] WHERE [BasicReferenceTypeID] = 8)
DELETE FROM [esf_sso].[BasicReference] WHERE [BasicReferenceTypeID] = 8;


INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AD', 'Andorra',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AE', 'United Arab Emirates',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AF', 'Afghanistan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AG', 'Antigua and Barbuda',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AI', 'Anguilla',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AL', 'Albania',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AM', 'Armenia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AN', 'Netherlands Antilles',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AO', 'Angola',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AQ', 'Antarctica',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AR', 'Argentina',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AS', 'American Samoa',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AT', 'Austria',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AU', 'Australia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AW', 'Aruba',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'AZ', 'Azerbaijan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BA', 'Bosnia and Herzegovina',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BB', 'Barbados',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BD', 'Bangladesh',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BE', 'Belgium',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BF', 'Burkina Faso',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BG', 'Bulgaria',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BH', 'Bahrain',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BI', 'Burundi',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BJ', 'Benin',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BL', 'Saint Barthélemy',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BM', 'Bermuda',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BN', 'Brunei Darussalam',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BO', 'Bolivia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BR', 'Brazil',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BS', 'Bahamas',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BT', 'Bhutan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BV', 'Bouvet Island',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BW', 'Botswana',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BY', 'Belarus',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'BZ', 'Belize',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CA', 'Canada',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CC', 'Cocos (Keeling) Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CD', 'Congo, The Democratic Republic Of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CF', 'Central African Republic',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CG', 'Congo',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CH', 'Switzerland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CI', 'Cote d''Ivoire',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CK', 'Cook Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CL', 'Chile',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CM', 'Cameroon',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CN', 'China',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CO', 'Colombia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CR', 'Costa Rica',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CS', 'Serbia and Montenegro',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CU', 'Cuba',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CV', 'Cape Verde',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CX', 'Christmas Island',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CY', 'Cyprus',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'CZ', 'Czech Republic',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DE', 'Germany',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DJ', 'Djibouti',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DK', 'Denmark',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DM', 'Dominica',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DO', 'Dominican Republic',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'DZ', 'Algeria',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'EC', 'Ecuador',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'EE', 'Estonia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'EG', 'Egypt',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'EH', 'Western Sahara',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ER', 'Eritrea',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ES', 'Spain',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ET', 'Ethiopia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FI', 'Finland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FJ', 'Fiji',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FK', 'Falkland Islands (Malvinas)',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FM', 'Micronesia, Federated States of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FO', 'Faroe Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'FR', 'France',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GA', 'Gabon',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GB', 'United Kingdom',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GD', 'Grenada',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GE', 'Georgia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GF', 'French Guiana',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GG', 'Guernsey',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GH', 'Ghana',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GI', 'Gibraltar',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GL', 'Greenland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GM', 'Gambia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GN', 'Guinea',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GP', 'Guadeloupe',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GQ', 'Equatorial Guinea',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GR', 'Greece',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GS', 'South Georgia and The South Sandwich Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GT', 'Guatemala',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GU', 'Guam',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GW', 'Guinea-Bissau',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'GY', 'Guyana',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HK', 'Hong Kong',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HM', 'Heard Island And McDonald Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HN', 'Honduras',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HR', 'Croatia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HT', 'Haiti',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'HU', 'Hungary',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ID', 'Indonesia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IE', 'Ireland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IL', 'Israel',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IM', 'Isle of Man',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IN', 'India',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IO', 'British Indian Ocean Territory',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IQ', 'Iraq',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IR', 'Iran, Islamic Republic Of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IS', 'Iceland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'IT', 'Italy',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'JE', 'Jersey',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'JM', 'Jamaica',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'JO', 'Jordan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'JP', 'Japan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KE', 'Kenya',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KG', 'Kyrgyzstan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KH', 'Cambodia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KI', 'Kiribati',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KM', 'Comoros',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KN', 'Saint Kitts and Nevis',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KP', 'Korea, Democratic People''s Republic Of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KR', 'Korea, Republic Of-South',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KW', 'Kuwait',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KY', 'Cayman Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'KZ', 'Kazakstan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LA', 'Lao People''s Democratic Republic',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LB', 'Lebanon',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LC', 'Saint Lucia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LI', 'Liechtenstein',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LK', 'Sri Lanka',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LR', 'Liberia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LS', 'Lesotho',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LT', 'Lithuania',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LU', 'Luxembourg',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LV', 'Latvia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'LY', 'Libyan Arab Jamahiriya',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MA', 'Morocco',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MC', 'Monaco',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MD', 'Moldova, Republic of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ME', 'Montenegro',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MG', 'Madagascar',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MH', 'Marshall Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MK', 'Macedonia, The Former Yugoslav Republic of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ML', 'Mali',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MM', 'Myanmar',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MN', 'Mongolia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MO', 'Macau',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MP', 'Northern Mariana Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MQ', 'Martinique',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MR', 'Mauritania',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MS', 'Montserrat',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MT', 'Malta',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MU', 'Mauritius',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MV', 'Maldives',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MW', 'Malawi',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MX', 'Mexico',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MY', 'Malaysia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'MZ', 'Mozambique',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NA', 'Namibia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NC', 'New Caledonia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NE', 'Niger',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NF', 'Norfolk Island',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NG', 'Nigeria',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NI', 'Nicaragua',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NL', 'Netherlands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NO', 'Norway',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NP', 'Nepal',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NR', 'Nauru',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NU', 'Niue',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'NZ', 'New Zealand',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'OM', 'Oman',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PA', 'Panama',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PE', 'Peru',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PF', 'French Polynesia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PG', 'Papua New Guinea',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PH', 'Philippines',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PK', 'Pakistan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PL', 'Poland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PM', 'Saint Pierre and Miquelon',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PN', 'Pitcairn',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PR', 'Puerto Rico',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PS', 'Palestinian Territory, Occupied',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PT', 'Portugal',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PW', 'Palau',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'PY', 'Paraguay',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'QA', 'Qatar',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'RE', 'Reunion',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'RO', 'Romania',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'RS', 'Serbia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'RU', 'Russian Federation',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'RW', 'Rwanda',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SA', 'Saudi Arabia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SB', 'Solomon Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SC', 'Seychelles',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SD', 'Sudan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SE', 'Sweden',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SG', 'Singapore',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SH', 'Saint Helena',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SI', 'Slovenia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SJ', 'Svalbard And Jan Mayen',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SK', 'Slovakia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SL', 'Sierra Leone',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SM', 'San Marino',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SN', 'Senegal',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SO', 'Somalia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SR', 'Suriname',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ST', 'Sao Tome and Principe',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SV', 'El Salvador',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SY', 'Syrian Arab Republic',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'SZ', 'Swaziland',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TC', 'Turks and Caicos Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TD', 'Chad',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TF', 'French Southern Territories',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TG', 'Togo',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TH', 'Thailand',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TJ', 'Tajikistan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TK', 'Tokelau',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TL', 'Timor-Leste',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TM', 'Turkmenistan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TN', 'Tunisia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TO', 'Tonga',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TP', 'East Timor',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TR', 'Turkey',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TT', 'Trinidad and Tobago',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TV', 'Tuvalu',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TW', 'Taiwan, Province of China',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'TZ', 'Tanzania, United Republic Of',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'UA', 'Ukraine',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'UG', 'Uganda',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'UM', 'United States Minor Outlying Islands',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'US', 'United States',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'UY', 'Uruguay',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'UZ', 'Uzbekistan',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VA', 'Holy See (Vatican City State)',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VC', 'Saint Vincent and The Grenadines',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VE', 'Venezuela',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VG', 'Virgin Islands, British',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VI', 'Virgin Islands, U.S.',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VN', 'Vietnam',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'VU', 'Vanuatu',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'WF', 'Wallis and Futuna',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'WS', 'Samoa',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'YE', 'Yemen',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'YT', 'Mayotte',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'YU', 'Yugoslavia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ZA', 'South Africa',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ZM', 'Zambia',1,GETDATE(), 'root');
INSERT INTO [esf_sso].BasicReference ([BasicReferenceTypeID],[Code],[Name],[IsEnabled],[CreationDateTime],UserCreationAlias) VALUES (8, 'ZW', 'Zimbabwe',1,GETDATE(), 'root');

-- ============================================================
-- Vinculo Pais
-- ============================================================

INSERT INTO [esf_sso].TreeBasicReference (ParentBasicReferenceID, BasicReferenceID)
SELECT
	C.ID, NULL
FROM
	[esf_sso].VCountry C